How to: Prevent users from editing the same record in a query or form.
Solution:
Select the entire query or form, select 'Properties' from the 'View' menu, and select 'Edited Record' from the 'Record Locks' drop-down list.
1) In the Query Design or Form Design view, select the entire form or query by doing one of the following:
a) To select an entire form, click on the button on the upper-left corner of the form.
Selecting an entire form
b) To select an entire query, click anywhere outside the design grid and the field lists.
2) Select the 'View' menu and select 'Properties'. (The Form Properties or Query Properties sheet appears.)
3) Click in the 'Record Locks' property box. (A down-arrow button appears.)
4) Click on the down arrow. (A drop-down list appears.)
5) Select 'Edited Record' from the 'Record Locks' drop-down list.
Edited Record
NOTE: Access locks the record that is being edited. This option ensures that only one person works on a record at a time and avoid editing conflicts.
